/*
 Navicat Premium Data Transfer

 Source Server         : LocalMysql
 Source Server Type    : MySQL
 Source Server Version : 50731
 Source Host           : localhost:3306
 Source Schema         : springclouddata

 Target Server Type    : MySQL
 Target Server Version : 50731
 File Encoding         : 65001

 Date: 12/03/2021 08:36:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(50) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `flag` varchar(2) DEFAULT NULL,
  `goods_desc` varchar(100) DEFAULT NULL,
  `images` varchar(400) DEFAULT NULL,
  `goods_stock` int(11) DEFAULT NULL,
  `goods_type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of goods
-- ----------------------------
BEGIN;
INSERT INTO `goods` VALUES (1, '华为plus_1', 4500, '1', '性能爆发，拒绝卡顿', 'https://portrait.gitee.com/uploads/avatars/user/2451/7353189_sfljskeprim_admin_1585047341.png!avatar30', 10, '1');
INSERT INTO `goods` VALUES (2, '小米10', 3999, '0', '手机中的战斗机', 'https:', 1001, '1');
INSERT INTO `goods` VALUES (3, '小米11', 4999, '1', '手机中的王牌机', 'https:', 99, '1');
INSERT INTO `goods` VALUES (4, '小爱音箱', 199, '1', '智能音箱', 'https:', 100, '2');
INSERT INTO `goods` VALUES (5, 'IPHONE', 7999, '1', '苹果手机', 'https:', 1000, '1');
INSERT INTO `goods` VALUES (6, 'Mac Pro', 13999, '1', '苹果电脑', 'https:', 999, '3');
INSERT INTO `goods` VALUES (8, '保温杯', 199, '1', '保温杯', '111', 22, '4');
INSERT INTO `goods` VALUES (9, '毛巾', 48, '1', '毛巾', '11111', 999, '5');
INSERT INTO `goods` VALUES (10, '三件套', 88, '1', '床上三件套', '1111', 9999, '5');
INSERT INTO `goods` VALUES (12, '手机1', 2000, '1', '111', '111', 10, '1');
INSERT INTO `goods` VALUES (13, '手机2', 2100, '1', '111', '111', 12, '1');
INSERT INTO `goods` VALUES (14, '手机3', 2200, '1', '111', '111', 13, '1');
INSERT INTO `goods` VALUES (15, '手机4', 2300, '1', '111', '111', 14, '1');
INSERT INTO `goods` VALUES (16, '手机5', 2400, '1', '111', '111', 15, '1');
INSERT INTO `goods` VALUES (17, '手机6', 2500, '1', '111', '111', 16, '1');
INSERT INTO `goods` VALUES (18, '手机7', 2600, '1', '111', '111', 17, '1');
COMMIT;

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pay_type` tinyint(2) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `is_delete` tinyint(1) DEFAULT '0',
  `total_amount` decimal(10,2) DEFAULT NULL,
  `real_amount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of order
-- ----------------------------
BEGIN;
INSERT INTO `order` VALUES (1, 10, '2021-03-11 17:01:33', NULL, 0, 8499.00, 8400.00);
INSERT INTO `order` VALUES (2, 10, '2021-03-11 19:52:41', NULL, 0, 0.00, 0.00);
INSERT INTO `order` VALUES (3, 10, '2021-03-11 19:54:15', NULL, 0, 0.00, 0.00);
INSERT INTO `order` VALUES (4, 10, '2021-03-11 19:54:30', NULL, 0, 0.00, 0.00);
COMMIT;

-- ----------------------------
-- Table structure for order_item
-- ----------------------------
DROP TABLE IF EXISTS `order_item`;
CREATE TABLE `order_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `buy_counts` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of order_item
-- ----------------------------
BEGIN;
INSERT INTO `order_item` VALUES (1, 1, 1, '华为plus', 4500.00, 1);
INSERT INTO `order_item` VALUES (2, 1, 2, '小米10', 3999.00, 1);
COMMIT;

-- ----------------------------
-- Table structure for order_status
-- ----------------------------
DROP TABLE IF EXISTS `order_status`;
CREATE TABLE `order_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL,
  `status` tinyint(2) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `pay_time` datetime DEFAULT NULL,
  `close_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of order_status
-- ----------------------------
BEGIN;
INSERT INTO `order_status` VALUES (1, 1, 0, '2021-03-11 17:03:29', '2021-03-11 16:02:34', NULL);
INSERT INTO `order_status` VALUES (2, 2, 0, '2021-03-11 19:54:49', NULL, NULL);
INSERT INTO `order_status` VALUES (3, 3, 0, '2021-03-11 19:54:57', NULL, NULL);
INSERT INTO `order_status` VALUES (4, 4, 0, '2021-03-11 19:55:03', NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
